﻿CREATE TABLE [dbo].[content_item_tags] (
    [content_item_id] BIGINT NOT NULL,
    [tag_id]          BIGINT NOT NULL,
    CONSTRAINT [PK_content_item_tags] PRIMARY KEY CLUSTERED ([content_item_id] ASC, [tag_id] ASC),
    CONSTRAINT [FK_content_item_tags_content_item] FOREIGN KEY ([content_item_id]) REFERENCES [dbo].[content_item] ([content_item_id]),
    CONSTRAINT [FK_content_item_tags_tags] FOREIGN KEY ([tag_id]) REFERENCES [dbo].[tags] ([tag_id])
);

